#Java - Code Snippets for '#Java.sql.ResultSet' - 2 code snippet(s) found |
|
Sample 1. Code Sample / Example / Snippet of java.sql.ResultSetMetaData | |
|
private void output(ResultSet resultSet, PrintStream out)
throws SQLException {
final ResultSetMetaData metaData = resultSet.getMetaData();
final int columnCount = metaData.getColumnCount();
while (resultSet.next()) {
for (int i = 1;; i++) {
out.print(resultSet.getString(i));
if (i < columnCount) {
out.print(", ");
} else {
out.println();
break;
}
}
}
}
|
|
Like Feedback java.sql.ResultSetMetaData |
|
|
Sample 2. Code Sample / Example / Snippet of java.sql.ResultSet | |
|
public String prepareBindExecute(HrConnection state) throws SQLException {
Connection con = state.con;
Statement st = null;
ResultSet rs = null;
String ename = null;
try {
final PreparedStatement ps =
con.prepareStatement("select name from emps where empid = ?");
st = ps;
ps.setInt(1, state.id);
rs = ps.executeQuery();
rs.next();
ename = rs.getString(1);
} finally {
close(rs, st);
}
return ename;
}
|
|
Like Feedback java.sql.ResultSet |
|
|